﻿USE [syncdb]
GO

/****** Object:  View [dbo].[vw_cust_custwork_detailinfo]    Script Date: 2024-11-21 10:44:35 ******/
DROP VIEW [dbo].[vw_cust_custwork_detailinfo]
GO

/****** Object:  View [dbo].[vw_cust_custwork_detailinfo]    Script Date: 2024-11-21 10:44:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE   view [dbo].[vw_cust_custwork_detailinfo]
as

select corp 公司, iyear 年度, imonth 月, citemcode 项目编码 , citemname 项目名称 , preqty 期初数量, ccqty 本期拆除, djqty 本期搭建, balqty 期末数量, 
curcb 本月成本小计, curcb1 [施工成本-工资薪金], curcb2 [施工成本-福利费], curcb3 [施工成本-社保], curcb4 [施工成本-公积金], curcb5 [施工成本-职工教育经费], curcb6 [施工成本-工会经费], curcb7 [施工成本-解除劳动关系补偿], curcb8 [施工成本-劳务费], curcb9 [施工成本-办公费用], curcb10 [施工成本-差旅费],  curcb11 [施工成本-业务招待费], curcb12 [施工成本-保险费], curcb13 [施工成本-运杂费], curcb14 [施工成本-借租费], curcb15 [施工成本-折旧费(经营)], curcb16 [施工成本-折旧费(自用)], curcb17 [施工成本-车辆费用], curcb18 [施工成本--物料消耗], curcb19 [施工成本-劳动保护费], curcb20 [施工成本-内部租借费] , curcb21 [施工成本-仓储费用],
jzcb 结转施工成本小计, jzcb1 [结转成本-工资薪金],jzcb2 [结转成本-福利费],jzcb3 [结转成本-社保],jzcb4  [结转成本-公积金],jzcb5 [结转成本-职工教育经费],jzcb6 [结转成本-工会经费],jzcb7 [结转成本-解除劳动关系补偿],jzcb8  [结转成本-劳务费],jzcb9 [结转成本-办公费用],jzcb10 [结转成本-差旅费],jzcb11 [结转成本-业务招待费],jzcb12 [结转成本-保险费],jzcb13 [结转成本-运杂费],jzcb14 [结转成本-借租费],jzcb15 [结转成本-折旧费(经营)],jzcb16 [结转成本-折旧费(自用)],jzcb17 [结转成本-车辆费用],jzcb18 [结转成本--物料消耗],jzcb19 [结转成本-劳动保护费],jzcb20 [结转成本-内部租借费],jzcb21 [结转成本-仓储费用],
jzqcb 结转前施工成本小计,jzqcb1 [结转前成本-工资薪金],jzqcb2 [结转前成本-福利费],jzqcb3 [结转前成本-社保],jzqcb4  [结转前成本-公积金],jzqcb5 [结转前成本-职工教育经费],jzqcb6 [结转前成本-工会经费],jzqcb7 [结转前成本-解除劳动关系补偿],jzqcb8  [结转前成本-劳务费],jzqcb9 [结转前成本-办公费用],jzqcb10 [结转前成本-差旅费],jzqcb11 [结转前成本-业务招待费],jzqcb12 [结转前成本-保险费],jzqcb13 [结转前成本-运杂费],jzqcb14 [结转前成本-借租费],jzqcb15 [结转前成本-折旧费(经营)],jzqcb16 [结转前成本-折旧费(自用)],jzqcb17 [结转前成本-车辆费用],jzqcb18 [结转前成本--物料消耗],jzqcb19 [结转前成本-劳动保护费],jzqcb20 [结转前成本-内部租借费],jzqcb21 [结转前成本-仓储费用],
avgcb 单方成本,avgcb1 [单方成本-工资薪金] ,avgcb2 [单方成本-福利费],avgcb3 [单方成本-社保],avgcb4  [单方成本-公积金],avgcb5 [单方成本-职工教育经费],avgcb6 [单方成本-工会经费],avgcb7 [单方成本-解除劳动关系补偿],avgcb8  [单方成本-劳务费],avgcb9 [单方成本-办公费用],avgcb10 [单方成本-差旅费],avgcb11 [单方成本-业务招待费],avgcb12 [单方成本-保险费],avgcb13 [单方成本-运杂费],avgcb14 [单方成本-借租费],avgcb15 [单方成本-折旧费(经营)],avgcb16 [单方成本-折旧费(自用)],avgcb17 [单方成本-车辆费用],avgcb18 [单方成本--物料消耗],avgcb19 [单方成本-劳动保护费],avgcb20 [单方成本-内部租借费],avgcb21 [单方成本-仓储费用]
from custwork_detailinfo
GO


